County Profile for Honolulu - 2017



County Controls Information

Cost Report Counts Population
Total Hospital Count 13 Total Population on July 31, 2017 0
Total Cost Reports Filed in 2017 13 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 6 Net Population Natural Change 0
Total Cost Reports Reopened 6 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 1 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 1,651,757,523 Total Charges 6,442,566,390
Fixed Assets 1,010,062,250 Contract Allowance 3,935,342,588
Other Assets 212,953,581 Operating Revenue 2,507,223,802
Total Assets 2,874,773,354 Operating Expenses 2,891,042,204
Current Liabilities 384,813,704 Operating Margin -383,818,402
Long Term Liabilities 859,480,483 Other Income 236,071,211
Total Equity 1,630,479,167 Other Expense 2,546,275
Total Liabilities and Equity 2,874,773,354 Net Profit or Loss -150,293,466

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $31,565 Revenue per Bed $1,468,790 Revenue per Person $2,507,223,802
Net Margin per Discharge ($4,832) Net Margin per Bed ($224,850) Net Margin per Person ($383,818,402)
Net Profit per Discharge ($1,892) Net Profit per Bed ($88,045) Net Profit per Person ($150,293,466)
Net Fixed Assets per Discharge $12,716 Net Fixed Assets per Bed $591,718 Net Fixed Assets per Bed $1,010,062,250
Long Term Debt per Discharge $10,820 Long Term Debt per Bed $503,504 Long Term Debt per Person $859,480,483
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 71.7 %
Length of Stay 6 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 135 Net Fixed Assets 109 Population Estimate 1,151
Total Revenue 89 Long Term Liabilities 83 Total Patient Discharges 95
Net Margin 3,281 Total Patient Beds 79
Net Profit or Loss 3,292

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 591,696,201 913,625,215 0.6476
31 Intensive Care Unit 186,758,353 427,523,192 0.4368
32 Coronary Care Unit 2,922,856 5,660,891 0.5163
43 Nursery 16,987,898 28,557,242 0.5949
44 Skilled Nursing Care 36,008,446 33,583,562 1.0722
50 Operating Room 143,277,290 412,611,778 0.3472
51 Recovery Room 52,886,178 101,218,892 0.5225
52 Labor and Delivery Room 42,972,068 73,928,378 0.5813

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 66,238,604 13 Nursing Administration 35,467,255
02,03 Captial Related - Movable Equipment 42,764,024 14 Central Services and Supply 14,318,529
04 Employee Benefits 260,880,832 15 Pharmacy 69,643,742
05 Administrative and General 444,319,525 16 Medical Records and Medical Library 15,370,632
06 Maintenance and Repairs 38,616,482 17 Social Services 23,408,087
07 Operation of Plant 51,545,301 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 35,257,127 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 31,576,810 20,21,22,23 Education Programs 28,692,488
Total General Service Cost Centers 1,158,099,438

County Profile for Honolulu - 2017